home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
rptnames.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
902b
|
23 lines
/* RCSVER $Id: rptnames.sql,v 1.2 2000-05-09 12:05:46-05 randy Exp $ */
/* *************************************************************************
* Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
*
* Name: rptnames.sql
* Date: 02/24/2000
* memo: Randy Wood
* Description: Create the rptnames table.
* Changes:
************************************************************************* */
CREATE TABLE rptnames
(
report_indx NUMBER(38), /* Number unique to this report */
report_name VARCHAR2(30), /* Name/title of this report */
short_name VARCHAR2(10), /* Abbreviated name */
is_customizable NUMBER(1), /* If =1, user headings are used; */
/* else =0 */
max_columns NUMBER(38), /* Maximum number of columns used by */
/* this report */
CONSTRAINT unq_rptnames UNIQUE(short_name),
CONSTRAINT pk_rptnames PRIMARY KEY (report_indx)
);